USE [C:\USERS\STEPHANIE HUANG\DESKTOP\WORLDTRADEBANK\APP_DATA\BANK.MDF]
GO

/****** Object:  Table [dbo].[R_APPLICATION]    Script Date: 12/13/2014 13:02:36 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[R_CHANGE_REQUEST](
	[request_id] [int] IDENTITY(1,1) NOT NULL,
	[first_name] [nvarchar](50) NULL,
	[last_name] [nvarchar](50) NULL,
	[new_nric] [nvarchar](50) NULL,
	[old_nric] [nvarchar](50) NULL,
	[mailing_address] [nvarchar](50) NULL,
	[postal_code] [nvarchar](50) NULL,
	[mobile_no] [nvarchar](50) NULL,
	[tel_no] [nvarchar](50) NULL,
	[email] [nvarchar](50) NULL,
	[occupation] [nvarchar](50) NULL,
	[job_duties] [nvarchar](50) NULL,
	[employer] [nvarchar](50) NULL,
	[effective_date] [date] NULL,
	[industry] [nvarchar](50) NULL,
	[inc_premium] [decimal](18, 2) NULL,
	[dec_premium] [decimal](18, 2) NULL,
	[inc_sum_insured] [decimal](18, 2) NULL,
	[dec_sum_insured] [decimal](18, 2) NULL,
	[inc_rider_name] [nvarchar](50) NULL,
	[inc__rider_sum_insured] [decimal](18, 2) NULL,
	[dec_rider_name] [nvarchar](50) NULL,
	[dec_rider_sum_insured] [decimal](18, 2) NULL,
	[add_rider_name] [nvarchar](50) NULL,
	[add_rider_sum_insured] [decimal](18, 2) NULL,
	[del_rider_name] [nvarchar](50) NULL,
	[del_rider_sum_insured] [decimal](18, 2) NULL
	
) 

GO


